USE [LAFDC]
GO
/****** Object:  Table [dbo].[Adherent]    Script Date: 11/23/2009 22:54:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Adherent](
	[PREV_ID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[RETENU] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AD] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SECTION] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[DATE_ADHESION] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[PREMIUM] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CREATED] [datetime] NULL,
	[LAST_MODIFIED] [datetime] NULL,
	[JOURNAL] [int] NULL,
	[JOURNAL_MODIFIED] [datetime] NULL,
 CONSTRAINT [PK_Adherent] PRIMARY KEY CLUSTERED 
(
	[PREV_ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
